package com.weixin.dao;

import java.sql.SQLException;
import java.util.List;

import com.weixin.entity.Purchase_People_Tb;



public interface Purchase_People_TbDAO {

		public List<Purchase_People_Tb> selectAll()throws SQLException;
		

		public boolean insert(Purchase_People_Tb people) throws SQLException;
		
		public boolean delete (int id) throws SQLException;

		public boolean updateDelete(int id) throws SQLException;

		public Purchase_People_Tb byId (int id) throws SQLException;

		public boolean update(Purchase_People_Tb  people)  throws SQLException;
	
		public List<Purchase_People_Tb> getAllBypage(int pageSize, Integer pageNum) throws SQLException;
		  
		public int getTotal() throws SQLException;
		
		public List<Purchase_People_Tb> listAllByRoleSearchPagination(String search, int pageSize, int pageNum)throws SQLException;
		
		public List<Purchase_People_Tb> getTotalBySearch(String search)throws SQLException;
}
